J. Craig Williams ✭✭✭✭✭✭

Overview

Overview

Email	jcwill23@gmail.com
Roles	Member
Badges	35

About Me

About Me

Area of Expertise
About Me	Smartsheet Certified User <br /><br />See:<br />https://ronin-global.com/contact-us-smartsheet-help/<br />to see info about me or how to contact me.<br />The password is "thankyou"<br /><br />Also I have posted tips and tricks for Smartsheet here:<br />https://ronin-global.com/category/smartsheet-help/
How I Use Smartsheet	Daily tasks, any around the house or longer than a few days projects, project management, resource management.
Linkedin	http://www.linkedin.com/in/jcwill23
Twitter Page

Analytics

4,105

Posts

53

Visits

23.8k

Points

Nov 21, 2015

Join Date

Feb 21, 2025

Last Active

Reactions

• Insightful 25

  25
• Vote Up 85

  85
• Awesome 3

  3

• Activity
• Discussions169
• Comments3.9K

• Enhancement Request: Default, Locked, Export Filters

  J. Craig Williams

  01/18/18
  Thank you very much for the New Row Filters released yesterday. This will free up several Zaps (www.zapier.com) that I sometimes use. Here's what I want next: LOCKED FILTER As either Admin*, be able …
  2 ·

• Re: CountIF a cell word starts with

  J. Craig Williams

  08/06/17
  I think what you are asking for is to check for the "Fail" at the beginning of the text string. If so, this =COUNTIF(Status1:Status10, LEFT(@cell, 4) = "Fail") would count the fir…
  1 ·

• Preferred Contact List dropdown best practice?

  J. Craig Williams

  06/01/18
  Is there an easy way to populate the preferred dropdown choices in a Contact List? If I had 50 (the limit), mentioned here https://help.smartsheet.com/articles/504619-column-types#contactlist do I ne…
  1 ·

• Re: Return 1st Day of Month for a Date

  J. Craig Williams

  01/07/17
  Wanda, To confirm, you want the first day of the month for any date provided? Assuming column is Invoice and row is 23: =DATE(YEAR(Invoice23),MONTH(Invoice23),1) Cheers, Craig
  1 ·

• Re: Sum rows that are not children

  J. Craig Williams

  06/01/16
  Jim, Except if there are more than two levels, then you'd need to know to divide by 3. I have many sheets indented more than 2 times, but not all of them. Craig
  1 ·

Next